﻿CREATE TABLE [acms].[PageVersions]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[PageId] [int] NOT NULL,
[SiteId] [int] NOT NULL,
[ParentId] int,
[Name] [varchar] (50) NOT NULL,
[DisplayName] [varchar] (50) NOT NULL,
[TemplateId] int,
[LoaderId] int,
[UserControlPath] [varchar] (200),
[Created] [datetime] NOT NULL CONSTRAINT [DF_PageVersion_Created] DEFAULT (getdate()),
[LastUpdated] [datetime] NOT NULL CONSTRAINT [DF_PageVersion_LastUpdated] DEFAULT (getdate()),
[CID] [int] NOT NULL CONSTRAINT [DF_PageVersion_ConcurentId] DEFAULT ((0)),
[StatusId] [int] NOT NULL DEFAULT ((1)),
[Sequence] [int] NOT NULL DEFAULT((0)),
[Default] [bit] NOT NULL DEFAULT((0)),
[Deleted] [bit] NOT NULL CONSTRAINT [DF_PageVersion_Deleted] DEFAULT ((0))
) ON [PRIMARY]


